package com.kma.summer2012.dao;

import com.kma.summer2012.model.CrumbsRequest;
import com.kma.summer2012.model.CrumbsUser;

import java.sql.SQLException;
import java.util.Collection;
import java.util.List;

public interface CrumbsRequestDAO extends DAO<CrumbsRequest> {
    public void add(CrumbsRequest o) throws SQLException;

    public CrumbsRequest initByAdditionalTools(int req) throws SQLException;

    public CrumbsRequest addRequest(CrumbsRequest o) throws SQLException;

    public CrumbsRequest getByClientId(int clientID) throws SQLException;

    public void update(CrumbsRequest o) throws SQLException;

    public CrumbsRequest getById(int id) throws SQLException;

    public Collection<CrumbsRequest> getAll() throws SQLException;

    public void delete(CrumbsRequest o) throws SQLException;

    public int findClientIdByRequest(Integer requestID) throws SQLException;

    public List<CrumbsRequest> getAllForUser(CrumbsUser user) throws SQLException;

    public List<CrumbsRequest> getAllClosed() throws SQLException;

    public void deleteAll(List<CrumbsRequest> requests) throws SQLException;
}
